﻿    /***************************************************************************************************
    **  Table:	    public.building
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Represents a registered building.
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial data
    ** 
    **  Status:
    **      Dev
    ** 
    ***************************************************************************************************/

	----------------------------------------------------------------------------
	-- Insert

    INSERT INTO public.building (project_id, full_name, display_name) VALUES ('1', 'Block 1', '1');
    INSERT INTO public.building (project_id, full_name, display_name) VALUES ('1', 'Block 2', '2');
    INSERT INTO public.building (project_id, full_name, display_name) VALUES ('1', 'Block 3', '3');

    INSERT INTO public.building (project_id, full_name, display_name) VALUES ('2', 'Tower A', 'A');
    INSERT INTO public.building (project_id, full_name, display_name) VALUES ('2', 'Tower B', 'B');
    INSERT INTO public.building (project_id, full_name, display_name) VALUES ('2', 'Tower C', 'C');
    INSERT INTO public.building (project_id, full_name, display_name) VALUES ('2', 'Tower D', 'D');


	----------------------------------------------------------------------------
	-- Select
    SELECT * FROM public.building;

    